Invalid: " . htmlspecialchars($name) . "
"; return; } $csvDomains[] = $name; $prices = []; foreach ($dbPriceCols as $col) { $idx = $colMap[$col] ?? null; $val = ($idx !== null) ? ($data[$idx] ?? '') : ''; $prices[] = is_numeric($val) ? floatval($val) : 0.00; } $check = $conn->prepare("SELECT id FROM domains WHERE name = ?"); $check->bind_param("s", $name); $check->execute(); $check->store_result(); if ($check->num_rows > 0) { if (array_sum($prices) == 0) { $del = $conn->prepare("DELETE FROM domains WHERE name = ?"); $del->bind_param("s", $name); $del->execute(); $del->close(); $messages[] = "" . htmlspecialchars($name) . " deleted
"; } else { $upd = $conn->prepare( "UPDATE domains SET realtld_price=?, flatfeenames_price=?, domainfoxx_price=?, vsatdomains_price=?, domainsala_price=?, godaddy_price=? WHERE name=?" ); $params = array_merge($prices, [$name]); $upd->bind_param("dddddds", ...$params); $upd->execute(); $upd->close(); } } elseif (array_sum($prices) > 0) { $ins = $conn->prepare( "INSERT INTO domains (name,realtld_price,flatfeenames_price,domainfoxx_price,vsatdomains_price,domainsala_price,godaddy_price) VALUES (?,?,?,?,?,?,?)" ); $ins->bind_param("sdddddd", $name, ...$prices); $ins->execute(); $ins->close(); $messages[] = "" . htmlspecialchars($name) . " added
"; } $check->close(); } try { $configPath = '/home/fvme60ccdm8r/config/config5.php'; if (!is_readable($configPath)) { throw new Exception("Config file missing or not readable at: " . $configPath); } require_once $configPath; $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME); $is_admin = !empty($_SESSION['admin_logged_in']); // Redirect logic for mapped domains pointing to VSATDomains server $requested_domain = normalizeHost($_SERVER['HTTP_HOST'] ?? ''); if ($requested_domain !== '' && $requested_domain !== 'vsatdomains.com' && $requested_domain !== 'www.vsatdomains.com') { $found = false; $stmt = $conn->prepare("SELECT 1 FROM dns_records WHERE domain_name = ? LIMIT 1"); $stmt->bind_param("s", $requested_domain); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 0) { $found = true; } $stmt->close(); if (!$found) { $stmt = $conn->prepare("SELECT 1 FROM domains WHERE name = ? LIMIT 1"); $stmt->bind_param("s", $requested_domain); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 0) { $found = true; } $stmt->close(); } if ($found) { $conn->close(); ob_end_clean(); redirect("/portfolio/landing.php?domain=" . urlencode($requested_domain)); } } if (isset($_GET['logout'])) { session_destroy(); redirect("/portfolio/index.php?page=1"); } // DB columns must match your table exactly $dbPriceCols = [ 'realtld_price', 'flatfeenames_price', 'domainfoxx_price', 'vsatdomains_price', 'domainsala_price', 'godaddy_price' ]; // Where to send buyers for each seller button // VSATDomains is internal now, so it uses /portfolio/purchase.php $publicSellers = [ 'domainsala_price' => ['label' => 'DomainSala', 'url' => 'http://domainsala.com/purchase.php'], 'realtld_price' => ['label' => 'RealTLD', 'url' => 'http://realtld.com/purchase.php'], 'vsatdomains_price' => ['label' => 'VSATDomains', 'url' => '/portfolio/purchase.php'], 'domainfoxx_price' => ['label' => 'DomainFoxx', 'url' => 'http://domainfoxx.com/purchase.php'], 'flatfeenames_price' => ['label' => 'FlatFeeNames', 'url' => 'http://flatfeenames.com/purchase.php'], 'godaddy_price' => ['label' => 'GoDaddy', 'url' => 'https://www.godaddy.com/domains/searchresults.aspx?domainToCheck='] ]; $domainHeaderAliases = ['domain name','domain','name','domain_name','domainname']; $priceHeaderAliases = [ 'realtld' => 'realtld_price', 'realtld_price' => 'realtld_price', 'flatfeenames' => 'flatfeenames_price', 'flatfeenames_price' => 'flatfeenames_price', 'domainfoxx' => 'domainfoxx_price', 'domainfoxx_price' => 'domainfoxx_price', 'vsatdomains' => 'vsatdomains_price', 'vsatdomains_price' => 'vsatdomains_price', 'domainsala' => 'domainsala_price', 'domainsala_price' => 'domainsala_price', 'godaddy' => 'godaddy_price', 'godaddy_price' => 'godaddy_price' ]; if ($_SERVER['REQUEST_METHOD'] === 'POST' && $is_admin) { if (isset($_POST['upload_domains_csv'], $_FILES['csv_file'])) { $messages = []; $csvDomains = []; if (($handle = fopen($_FILES['csv_file']['tmp_name'], "r")) !== false) { $firstRow = fgetcsv($handle, 5000, ",", '"', '\\'); if ($firstRow === false) { throw new Exception("CSV appears empty."); } $lowerFirstRow = array_map(function ($h) { return strtolower(trim((string)$h)); }, $firstRow); $hasHeader = false; foreach ($lowerFirstRow as $h) { if (in_array($h, $domainHeaderAliases, true) || isset($priceHeaderAliases[$h])) { $hasHeader = true; break; } } $colMap = []; $domainColIndex = 0; if ($hasHeader) { foreach ($lowerFirstRow as $i => $h) { if (in_array($h, $domainHeaderAliases, true)) { $domainColIndex = $i; continue; } if (isset($priceHeaderAliases[$h])) { $colMap[$priceHeaderAliases[$h]] = $i; } } } else { // No-header CSV fixed order: // 0 domain, 1 realtld, 2 flatfeenames, 3 domainfoxx, 4 vsatdomains, 5 domainsala, 6 godaddy $domainColIndex = 0; $fixed = [ 1 => 'realtld_price', 2 => 'flatfeenames_price', 3 => 'domainfoxx_price', 4 => 'vsatdomains_price', 5 => 'domainsala_price', 6 => 'godaddy_price' ]; foreach ($fixed as $i => $col) { $colMap[$col] = $i; } } if (!$hasHeader) { $data = $firstRow; processCsvRow($data, $domainColIndex, $colMap, $dbPriceCols, $conn, $messages, $csvDomains); } while (($data = fgetcsv($handle, 5000, ",", '"', '\\')) !== false) { processCsvRow($data, $domainColIndex, $colMap, $dbPriceCols, $conn, $messages, $csvDomains); } fclose($handle); } $csvDomains = array_values(array_unique($csvDomains)); if (count($csvDomains) > 0) { $placeholders = implode(',', array_fill(0, count($csvDomains), '?')); $types = str_repeat('s', count($csvDomains)); $delSql = "DELETE FROM domains WHERE name NOT IN ($placeholders)"; $delStmt = $conn->prepare($delSql); $delStmt->bind_param($types, ...$csvDomains); $delStmt->execute(); $deletedCount = $delStmt->affected_rows; $delStmt->close(); $messages[] = "Sync cleanup: {$deletedCount} domains removed because they were not in the CSV.
"; } else { $messages[] = "No valid domains found in CSV. Sync cleanup skipped.
"; } $_SESSION['csv_messages'] = $messages; redirect("/portfolio/index.php?page=1"); } if (isset($_POST['edit'])) { $name = trim($_POST['name'] ?? ''); $id = (int)($_POST['id'] ?? 0); $prices = array_map('floatval', [ $_POST['realtld_price'] ?? 0, $_POST['flatfeenames_price'] ?? 0, $_POST['domainfoxx_price'] ?? 0, $_POST['vsatdomains_price'] ?? 0, $_POST['domainsala_price'] ?? 0, $_POST['godaddy_price'] ?? 0 ]); $stmt = $conn->prepare( "UPDATE domains SET name=?, realtld_price=?, flatfeenames_price=?, domainfoxx_price=?, vsatdomains_price=?, domainsala_price=?, godaddy_price=? WHERE id=?" ); $params = array_merge([$name], $prices, [$id]); $stmt->bind_param("sddddddi", ...$params); $stmt->execute(); $stmt->close(); redirect("/portfolio/index.php?page=1"); } if (isset($_POST['add'])) { $name = trim($_POST['name'] ?? ''); $prices = array_map('floatval', [ $_POST['realtld_price'] ?? 0, $_POST['flatfeenames_price'] ?? 0, $_POST['domainfoxx_price'] ?? 0, $_POST['vsatdomains_price'] ?? 0, $_POST['domainsala_price'] ?? 0, $_POST['godaddy_price'] ?? 0 ]); $check = $conn->prepare("SELECT id FROM domains WHERE name = ?"); $check->bind_param("s", $name); $check->execute(); $check->store_result(); if ($check->num_rows == 0 && $name !== '') { $ins = $conn->prepare( "INSERT INTO domains (name,realtld_price,flatfeenames_price,domainfoxx_price,vsatdomains_price,domainsala_price,godaddy_price) VALUES (?,?,?,?,?,?,?)" ); $ins->bind_param("sdddddd", $name, ...$prices); $ins->execute(); $ins->close(); } $check->close(); redirect("/portfolio/index.php?page=1"); } } if (isset($_GET['delete'], $_GET['id']) && $is_admin) { $stmt = $conn->prepare("DELETE FROM domains WHERE id = ?"); $id = (int)$_GET['id']; $stmt->bind_param("i", $id); $stmt->execute(); $stmt->close(); redirect("/portfolio/index.php?page=1"); } if (isset($_GET['download_domains_csv']) && $is_admin) { header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="domains.csv"'); $output = fopen('php://output', 'w'); fputcsv($output, [ 'Domain Name', 'RealTLD', 'FlatFeeNames', 'DomainFoxx', 'VSATDomains', 'DomainSala', 'GoDaddy' ]); $res = $conn->query( "SELECT name,realtld_price,flatfeenames_price,domainfoxx_price,vsatdomains_price,domainsala_price,godaddy_price FROM domains ORDER BY name" ); while ($row = $res->fetch_assoc()) { fputcsv($output, $row); } $res->free(); $conn->close(); exit; } $messages = $_SESSION['csv_messages'] ?? []; unset($_SESSION['csv_messages']); $search = trim($_GET['search'] ?? ''); $page = max(1, (int)($_GET['page'] ?? 1)); $perPage = 24; $offset = ($page - 1) * $perPage; $whereSql = ""; $params = []; $types = ""; if ($search !== "") { $whereSql = "WHERE name LIKE ?"; $params[] = "%" . $search . "%"; $types .= "s"; } if ($whereSql) { $countStmt = $conn->prepare("SELECT COUNT(*) AS total FROM domains $whereSql"); $countStmt->bind_param($types, ...$params); $countStmt->execute(); $total = (int)$countStmt->get_result()->fetch_assoc()['total']; $countStmt->close(); } else { $total = (int)$conn->query("SELECT COUNT(*) AS total FROM domains")->fetch_assoc()['total']; } $totalPages = max(1, (int)ceil($total / $perPage)); if ($whereSql) { $sql = "SELECT * FROM domains $whereSql ORDER BY name LIMIT ? OFFSET ?"; $stmt = $conn->prepare($sql); $pageParams = array_merge($params, [$perPage, $offset]); $stmt->bind_param($types . "ii", ...$pageParams); } else { $sql = "SELECT * FROM domains ORDER BY name LIMIT ? OFFSET ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("ii", $perPage, $offset); } $stmt->execute(); $domains = $stmt->get_result()->fetch_all(MYSQLI_ASSOC); $stmt->close(); } catch (Throwable $e) { http_response_code(500); echo "";
echo "FATAL ERROR: " . htmlspecialchars($e->getMessage()) . "\n";
echo "File: " . htmlspecialchars($e->getFile()) . "\n";
echo "Line: " . (int)$e->getLine() . "\n";
echo "";
ob_end_flush();
exit;
}
?>
Your destination for premium domain names
No domains found.